UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UMN97Izy4YP6B1OAbbvjRm6mK9iIFwoKzWBiR4jblU='
WHERE
key_id = '49c6252019f743822d2125bf1a61858932c01f49eea53396a26e5f2ee62a03d2'
AND (
token = '7UMN97Izy4YP6B1OAbbvjRm6mK9iIFwoKzWBiR4jblU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)