UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7XVVgSblBS76OOaKRQ9JN5j26GVIwlOCviU428eQaw='
WHERE
key_id = '7746863794e23f0eeb27bea28cb4df6b667525f278a761eb6563fc1c3aab35fb'
AND (
token = 'G7XVVgSblBS76OOaKRQ9JN5j26GVIwlOCviU428eQaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)