UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rLp0vUGSfEWa9JEPlkpDzzWl7Wfiog3ILIsrV6uLu0='
WHERE
key_id = 'df1bc28f77b535ba83213893588ca1d25591690945038dc25a8fcabf3bee3559'
AND (
token = '8rLp0vUGSfEWa9JEPlkpDzzWl7Wfiog3ILIsrV6uLu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)