UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h9rCpcjd2mhK94qpsQdWr2tQr5hzyJDuBUeLWnGbq2w='
WHERE
key_id = '5a6ed15b5b31bd925a0b4836db6a530359c911730cabeac679ed032843e13889'
AND (
token = 'h9rCpcjd2mhK94qpsQdWr2tQr5hzyJDuBUeLWnGbq2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)