UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3PqWABq2gX1e1gTiGHXBVxdZWOm8otI4MjVaVMWwhoE='
WHERE
key_id = '011780ec2c3b3075e896f93f0943aa4548e9c356340ed5504928835f3ab45d0a'
AND (
token = '3PqWABq2gX1e1gTiGHXBVxdZWOm8otI4MjVaVMWwhoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)