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