UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWgC7GRie8YhpGlAXUhckT5JcdCRBjeJ7la7KcrLM1g='
WHERE
key_id = 'ac0b13b4ab2e9d12ada122ba5e94ad10c048e8dd042889f6c053d255ce30e6e6'
AND (
token = 'ZWgC7GRie8YhpGlAXUhckT5JcdCRBjeJ7la7KcrLM1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)