UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ir6BrkqFCLEtO2XAHUysr/oYOYz/oPsXwTvhDSN698g='
WHERE
key_id = '8c4512e5e9728b90dbe511fdd6b5c12484ebacfebeb8b288cb2009923fe47830'
AND (
token = 'ir6BrkqFCLEtO2XAHUysr/oYOYz/oPsXwTvhDSN698g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)