UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hAcwCZXn3nbaS/jDaqRER2inBSUf+ED3jLInBdJ1fpA='
WHERE
key_id = 'd2b2e29316669f211d349ecd29d87e40ebec33952e5ffaa778df480df14c998f'
AND (
token = 'hAcwCZXn3nbaS/jDaqRER2inBSUf+ED3jLInBdJ1fpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)