UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9sWwxRb+5eKEGYV3Wi8W2wXTgG/A7hUqIdSwmEYjKlk='
WHERE
key_id = '6a0ec86ae60cebe64cb6f92899302935427fd907291c4782a028c5231ff62fae'
AND (
token = '9sWwxRb+5eKEGYV3Wi8W2wXTgG/A7hUqIdSwmEYjKlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)