UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q529GPQxGkiA/SrAirSPbd6jq8/2Af9OXodnqjcg9mg='
WHERE
key_id = 'd9a2b2a2ced578ff1a0038596856a807fa346bf70c9b8c65f307509a9625cd6d'
AND (
token = 'q529GPQxGkiA/SrAirSPbd6jq8/2Af9OXodnqjcg9mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)