UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/K8/Kiut8wMAe7c6clpN36eGdrFIdYRv9WzPqLl4Z2I='
WHERE
key_id = '974eb1e5a0555313f8aa4c886f3ff4a7e547784d5c0b595acd27927fc679a0d3'
AND (
token = '/K8/Kiut8wMAe7c6clpN36eGdrFIdYRv9WzPqLl4Z2I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)