UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Eb0YLXpjlDUF64I2ME4E675Pi6MIKlZpe+Yj21Ivys='
WHERE
key_id = '110a98317f923ee1854fba5617fcd1502b447b64a42618b987d1058558ea4ede'
AND (
token = '1Eb0YLXpjlDUF64I2ME4E675Pi6MIKlZpe+Yj21Ivys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)