UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kptiKkM7x0U1bgL7+/3UDm3BfZGdCfOTeeTmJAguZk8='
WHERE
key_id = 'd711f65bd564184d7d7ec2201ecd98a2f80741edbfe3eb4b2c5a924ed63ed820'
AND (
token = 'kptiKkM7x0U1bgL7+/3UDm3BfZGdCfOTeeTmJAguZk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)