UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EMyq9N4bbiyV+kklMc7wxW6MoL4rVJTDsVN9Hg42RD4='
WHERE
key_id = '294c01a105a1086b4afe212b2ad53837c21765284e7abf108bdf7c8f0c955e4e'
AND (
token = 'EMyq9N4bbiyV+kklMc7wxW6MoL4rVJTDsVN9Hg42RD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)