UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HW/UHhft7d7lh5QbAh4lykMUi4O1XDFpuMahM4RmCKs='
WHERE
key_id = '918d63debed74796f945467045cb1fa34477731a53424a100ed305f05d716d38'
AND (
token = 'HW/UHhft7d7lh5QbAh4lykMUi4O1XDFpuMahM4RmCKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)