UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0E31NTiqcLUuWeSusfQebs8NXS6imxXF2z5lctbftHQ='
WHERE
key_id = '9fed1c03d9d896b8ed1a67e6e33e9cb5df9c2d5338f0c491b35c6244f2116c40'
AND (
token = '0E31NTiqcLUuWeSusfQebs8NXS6imxXF2z5lctbftHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)