UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/JchL6moOABSvw5uGw0tS9hmpgy/7bBZHq0itYKIbGo='
WHERE
key_id = '3286870c93bc1cca27a7c70aeb007b7b7ec45e75563a138c01f8beb8ca5d285a'
AND (
token = '/JchL6moOABSvw5uGw0tS9hmpgy/7bBZHq0itYKIbGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)