UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sGIAHWt3NScJubeTq4AP91Wb2cqe2vggLXAL6se8ebw='
WHERE
key_id = 'ca3da75a36d4923df52d3997eeaaf3469e67a4afc27a3877d47eb2ee3a18cdff'
AND (
token = 'sGIAHWt3NScJubeTq4AP91Wb2cqe2vggLXAL6se8ebw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)