UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pxnTo90JiApLrtjsV5JiCznVleOPonex9oMiLOtcO80='
WHERE
key_id = '036d4f9766a66123a935d54a61413a2ae495346f6de984596dbe5e60564a9c12'
AND (
token = 'pxnTo90JiApLrtjsV5JiCznVleOPonex9oMiLOtcO80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)