UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VQ32KIiLEeE05QnVZb2LfiH7ouSrI0Pta4vddh/pwsE='
WHERE
key_id = 'a27c99f0b2600d3e8dbcf82ff1b7e52d29e50cd70477c8bfd5d13bb33cf9b9ee'
AND (
token = 'VQ32KIiLEeE05QnVZb2LfiH7ouSrI0Pta4vddh/pwsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)