UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7I6xAEZWN0N8B+vMfPYa8o8l4oke1Kh69mq/jljS1M='
WHERE
key_id = 'd0a5a6a3896b0366347feeeea3fc6a9c79e75ab4916acb85510edf021d137172'
AND (
token = 'z7I6xAEZWN0N8B+vMfPYa8o8l4oke1Kh69mq/jljS1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)