UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7QTFrt34SGA4BiHWUcQu1NPURoIiMdeHG6r6TJXgkqo='
WHERE
key_id = '189bddbfda35571812f4791ff7f6195884e17f6e4561fc25774ae1872cc618cb'
AND (
token = '7QTFrt34SGA4BiHWUcQu1NPURoIiMdeHG6r6TJXgkqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)