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