UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r2nCGlD6hhgB4yiLK6pj1jyhAaoKX/yxZFuxmJjdZGw='
WHERE
key_id = 'ff1e72cee79f045c73fca1f56c28f267073b0dafd3239613fab3d26c17ad85c1'
AND (
token = 'r2nCGlD6hhgB4yiLK6pj1jyhAaoKX/yxZFuxmJjdZGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)