UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aYwf1ya+f0TUC3J0mo3Fe3FUimdvd5E3iUOktrhipDU='
WHERE
key_id = '4e0c18f2ff2b7a45c7c9cdbbd16d5cb6c55750d84db5ba4f54237e6dc295fa77'
AND (
token = 'aYwf1ya+f0TUC3J0mo3Fe3FUimdvd5E3iUOktrhipDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)