UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Rr6V9YiItbfjKI8dTDeDq5Eh5EwE65oIsKoXWS4qmU='
WHERE
key_id = 'b263de4ec3d54a17500458a114784805d0600b2abb923a1c6620541c83ace287'
AND (
token = '9Rr6V9YiItbfjKI8dTDeDq5Eh5EwE65oIsKoXWS4qmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)