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