UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q9+VKm/qXPH+lg3km+9RANxWZGRMnwB3le4cT9PvhnE='
WHERE
key_id = 'd6373cbea4775a7fd70ab787c027f9adb046de0e9bef1cfc42ca2be7f6ea42c9'
AND (
token = 'q9+VKm/qXPH+lg3km+9RANxWZGRMnwB3le4cT9PvhnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)