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