UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Gd3suHfPEeOiOtgU4RFl3M/V8G0h6OD1i/JJuaNUck='
WHERE
key_id = 'fed273aa8e99634d0a9f3e378d52ccf44eae3f56a2dd914c9386cedad2db3218'
AND (
token = '8Gd3suHfPEeOiOtgU4RFl3M/V8G0h6OD1i/JJuaNUck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)