UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+i5/pR2g51A0EEYXb+nfzzGWqIsibdmGKiW7K/K9ofA='
WHERE
key_id = '111fd1e247896e460feae17a4fb219f3caecc3b0c578cb9c74fd1d15014529de'
AND (
token = '+i5/pR2g51A0EEYXb+nfzzGWqIsibdmGKiW7K/K9ofA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)