UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6JajfUNcEbfKaC3psTt2wi2fc2sJEaN214iN/Hk+Cpg='
WHERE
key_id = 'ab7aff8688c01f09ebf445b277f3e414f231c40d3554a12dfa9616cec47b1ddc'
AND (
token = '6JajfUNcEbfKaC3psTt2wi2fc2sJEaN214iN/Hk+Cpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)