UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BNnTdlYqTXnHRzDg3b0OPB2mXTbbHzxaTy1cC8m42n8='
WHERE
key_id = '1504e644802fc439e4063a4b193c6a9cdfca86ac54aa972a148169e4fd531b61'
AND (
token = 'BNnTdlYqTXnHRzDg3b0OPB2mXTbbHzxaTy1cC8m42n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)