UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0rkZorbVUd7Wb+ObCOBE2c4y8JmdT6wZuXpL1WGidSE='
WHERE
key_id = 'a97bc0d6a20b170784b596fee0a49550a2999eed859620e32cb6019054ecc019'
AND (
token = '0rkZorbVUd7Wb+ObCOBE2c4y8JmdT6wZuXpL1WGidSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)