UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wDY1WHc3hX2OCtCn7H93YXn0kMyvXrcNyrh6ti0ptOY='
WHERE
key_id = 'a316d82bb4009c01b763eaac079a8a8ef1262e996f88517390b3014d863872a7'
AND (
token = 'wDY1WHc3hX2OCtCn7H93YXn0kMyvXrcNyrh6ti0ptOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)