UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6P4S9MHsLMSJzPzxOSOUc7t4RLf8o9sgFQW1yYqn9Js='
WHERE
key_id = 'bee0b4e8eca13eb7086180283ec1a98577bdded0548bc0f18669fd57f4e3188c'
AND (
token = '6P4S9MHsLMSJzPzxOSOUc7t4RLf8o9sgFQW1yYqn9Js='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)