UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNSgRfHqfAKCpNkRa4z43Np7CbcIPGvA/Oo5smiA1dM='
WHERE
key_id = '86b08675f3edce836350b1a23936bbb476e73ddb0d653758150e5c35a95574a7'
AND (
token = 'sNSgRfHqfAKCpNkRa4z43Np7CbcIPGvA/Oo5smiA1dM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)