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