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