UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ff7QB29UwydAXr9Or9UCeIeM/B4d+UKc5vjPf/j7mA='
WHERE
key_id = 'fa833d5873a462e88aeae8a3e8a795aac0a539d33ea9548f1a3fccc3f8bee19b'
AND (
token = '8ff7QB29UwydAXr9Or9UCeIeM/B4d+UKc5vjPf/j7mA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)