UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gkHJ0F7Rg1AznThoBBdqQaZlFXPxOiIIqNLgNOoN3YQ='
WHERE
key_id = 'c6bf5812085a96a384e32b0ac8c9bf9d8740a2b6aff0937954d826eed7c70eba'
AND (
token = 'gkHJ0F7Rg1AznThoBBdqQaZlFXPxOiIIqNLgNOoN3YQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)