UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hTt3P6JH2IB0t2W3LOqnjuoggIN4jOV27eJTWLJVwIU='
WHERE
key_id = '920890660adb522277506950b2f580b4cac680bae580e5cc4dcb00142ccd1eb2'
AND (
token = 'hTt3P6JH2IB0t2W3LOqnjuoggIN4jOV27eJTWLJVwIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)