UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q6fRYDqHul6qNfyQoXCmmzr+kxlB819rWNwGUD1iHq8='
WHERE
key_id = 'b255659ef306a0642b2333c4525e4f70eb5ea84ec8d8bfce6f6ddf7cd96fcf75'
AND (
token = 'Q6fRYDqHul6qNfyQoXCmmzr+kxlB819rWNwGUD1iHq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)