UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cBftirSNyAnAN0qwwWvp/f52/lsdr5in5+07TZFqwnY='
WHERE
key_id = 'b975567fe66010e44032d7616644ae129d411250536f15686428d984b21b2ce3'
AND (
token = 'cBftirSNyAnAN0qwwWvp/f52/lsdr5in5+07TZFqwnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)