UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f85HnZaxpfHENoarICA6FBd6cnFAxAxBK4joFZC8J5E='
WHERE
key_id = '4030830ec4631a543b68f7864367155cc671051de98310aa1fc24618dff9018e'
AND (
token = 'f85HnZaxpfHENoarICA6FBd6cnFAxAxBK4joFZC8J5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)